//
//  DataBaseSingTon.h
//  newDouban
//
//  Created by dllo on 15/11/3.
//  Copyright © 2015年 蓝鸥科技. All rights reserved.
//

#import <Foundation/Foundation.h>
#import "Cinema.h"
#import "Activity.h"
#import "ActivityStore.h"
#import "User.h"
@interface DataBaseSingTon : NSObject

+ (instancetype)shareDataBase;

- (void)openDB;
- (void)createTable;
- (void)insertCinema:(Cinema *)cinema;
- (NSMutableArray *)selectCinema;
- (void)dropTable;


- (void)openDBAC;
- (void)createActivityTable;
- (void)insertActivity:(Activity *)act;
- (void)deleteActivity:(NSString *)sql;
- (NSMutableArray *)selectActivity:(NSString *)sql;
- (void)dropTableAC;



// 创建活动收藏列表
- (void)createActivityStoreTable;
//- (void)insertActivityStore:(ActivityStore *)actS;
- (void)insertActivitysql:(NSString *)sql;
- (NSMutableArray *)selectActivityStoreSQL:(NSString *)sql;
- (void)deleteActivityStoreWithTitle:(NSString *)title userName:(NSString *)name;
- (void)dropTableAC:(NSString *)sql;



- (void)createUserTable;
- (void)insertUser:(User *)user;
- (NSMutableArray *)selectUserSQL:(NSString *)sql;
- (void)updateUser:(NSString *)sql;

@end
